﻿using System;
using System.Data;
using Oracle.DataAccess.Client;
using Platform.Data;
using Entity;

namespace BLL
{
    /// <summary>
    /// 用于执行从临时表查询数据存储过程.(将sphelper中生成的方法复制过来修改修改)
    /// </summary>
    public class SearchSpHelper
    {
        public static DataSet P_YSJH_JIHUAZXQK(int? V_Y, int? V_M, int? V_JJBL)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_YSJH_JIHUAZXQK");
            storedParams[0].Value = V_Y;
            storedParams[1].Value = V_M;
            storedParams[2].Value = V_JJBL;
            DataSet ds = BaseDBHelper.RunSearch("P_YSJH_JIHUAZXQK", storedParams);
            return ds;
        }

        public static DataSet P_YSJH_YUBIANZHIJHFASJTJ(int? V_Y, int? V_TYPE, int? V_JJBL, int? V_WAY1, int? V_WAY2)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_YSJH_YUBIANZHIJHFASJTJ");
            storedParams[0].Value = V_Y;
            storedParams[1].Value = V_TYPE;
            storedParams[2].Value = V_JJBL;
            storedParams[3].Value = V_WAY1;
            storedParams[4].Value = V_WAY2;
            DataSet ds = BaseDBHelper.RunSearch("P_YSJH_YUBIANZHIJHFASJTJ", storedParams);
            return ds;
        }

        public static DataSet P_YSCX_ZLSGSSJCX_KHSL_JS(string V_Y, string V_M)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_YSCX_ZLSGSSJCX_KHSL_JS");
            storedParams[0].Value = V_Y;
            storedParams[1].Value = V_M;
            DataSet ds = BaseDBHelper.RunSearch("P_YSCX_ZLSGSSJCX_KHSL_JS", storedParams);
            return ds;
        }

        public static DataSet P_YS_CX_BENQIXX(string V_ZWY, string V_ZWM, string V_ZHANDIAN, string V_GUANLIKUAI, string V_YWY, string V_LTYPE, string V_TYPEVALUE, string V_JINETYPE, int? V_QIANFEI)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_YS_CX_BENQIXX");
            storedParams[0].Value = V_ZWY;
            storedParams[1].Value = V_ZWM;
            storedParams[2].Value = V_ZHANDIAN;
            storedParams[3].Value = V_GUANLIKUAI;
            storedParams[4].Value = V_YWY;
            storedParams[5].Value = V_LTYPE;
            storedParams[6].Value = V_TYPEVALUE;
            storedParams[7].Value = V_JINETYPE;
            storedParams[8].Value = V_QIANFEI;
            DataSet ds = BaseDBHelper.RunSearch("P_YS_CX_BENQIXX", storedParams);
            return ds;
        }

        public static DataSet P_YSCX_DUOSHOU(int? V_ZWY, int? V_ZWM, string V_ZHANDIAN, string V_GUANLIK, int? V_YWY, string V_YMPRE, int? V_YM, string V_YONGHUH, string V_YONGHUM, int V_NOTFP)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_YSCX_DUOSHOU");
            storedParams[0].Value = V_ZWY;
            storedParams[1].Value = V_ZWM;
            storedParams[2].Value = V_ZHANDIAN;
            storedParams[3].Value = V_GUANLIK;
            storedParams[4].Value = V_YWY;
            storedParams[5].Value = V_YMPRE;
            storedParams[6].Value = V_YM;
            storedParams[7].Value = V_YONGHUH;
            storedParams[8].Value = V_YONGHUM;
            storedParams[9].Value = V_NOTFP;
            DataSet ds = BaseDBHelper.RunSearch("P_YSCX_DUOSHOU", storedParams);
            return ds;
        }

        public static DataSet P_YS_CX_BENQIDZ(int? V_ZWY, int? V_ZWM, string V_ZHANDIAN, string V_GUANLIKUAI, string V_YWY, string V_LTYPE, string V_TYPEVALUE, string V_LTYPE1, string V_TYPEVALUE1, int? V_PAICHUSYYS, int? V_BAOHANSYYS)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_YS_CX_BENQIDZ");
            storedParams[0].Value = V_ZWY;
            storedParams[1].Value = V_ZWM;
            storedParams[2].Value = V_ZHANDIAN;
            storedParams[3].Value = V_GUANLIKUAI;
            storedParams[4].Value = V_YWY;
            storedParams[5].Value = V_LTYPE;
            storedParams[6].Value = V_TYPEVALUE;
            storedParams[7].Value = V_LTYPE1;
            storedParams[8].Value = V_TYPEVALUE1;
            storedParams[9].Value = V_PAICHUSYYS;
            storedParams[10].Value = V_BAOHANSYYS;
            DataSet ds = BaseDBHelper.RunSearch("P_YS_CX_BENQIDZ", storedParams);
            if (storedParams[0].Value is System.DBNull)
            {
                V_ZWY = null;
            }
            else
            {
                V_ZWY = Convert.ToInt32(storedParams[0].Value);
            }
            if (storedParams[1].Value is System.DBNull)
            {
                V_ZWM = null;
            }
            else
            {
                V_ZWM = Convert.ToInt32(storedParams[1].Value);
            }
            return ds;
        }

        public static DataSet P_YS_CX_BENQITP(int? V_ZWY, int? V_ZWM, string V_ZHANDIAN, string V_GUANLIKUAI, string V_YWY, string V_LTYPE, string V_TYPEVALUE, string V_LTYPE1, string V_TYPEVALUE1, int? V_SHIFOUTP)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_YS_CX_BENQITP");
            storedParams[0].Value = V_ZWY;
            storedParams[1].Value = V_ZWM;
            storedParams[2].Value = V_ZHANDIAN;
            storedParams[3].Value = V_GUANLIKUAI;
            storedParams[4].Value = V_YWY;
            storedParams[5].Value = V_LTYPE;
            storedParams[6].Value = V_TYPEVALUE;
            storedParams[7].Value = V_LTYPE1;
            storedParams[8].Value = V_TYPEVALUE1;
            storedParams[9].Value = V_SHIFOUTP;
            return BaseDBHelper.RunSearch("P_YS_CX_BENQITP", storedParams);
        }

        public static DataSet P_YS_CX_TUIKUAN(int? V_ZWY, int? V_ZWM, string V_ZHANDIAN, string V_GUANLIKUAI, string V_YWY, string V_LTYPE, string V_TYPEVALUE, string V_LTYPE1, string V_TYPEVALUE1)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_YS_CX_TUIKUAN");
            storedParams[0].Value = V_ZWY;
            storedParams[1].Value = V_ZWM;
            storedParams[2].Value = V_ZHANDIAN;
            storedParams[3].Value = V_GUANLIKUAI;
            storedParams[4].Value = V_YWY;
            storedParams[5].Value = V_LTYPE;
            storedParams[6].Value = V_TYPEVALUE;
            storedParams[7].Value = V_LTYPE1;
            storedParams[8].Value = V_TYPEVALUE1;
            DataSet ds = BaseDBHelper.RunSearch("P_YS_CX_TUIKUAN", storedParams);
            if (storedParams[0].Value is System.DBNull)
            {
                V_ZWY = null;
            }
            else
            {
                V_ZWY = Convert.ToInt32(storedParams[0].Value);
            }
            if (storedParams[1].Value is System.DBNull)
            {
                V_ZWM = null;
            }
            else
            {
                V_ZWM = Convert.ToInt32(storedParams[1].Value);
            }
            return ds;
        }

        public static DataSet P_YS_CX_YUEYONGSQK(string V_ZHANDIAN, string V_GUANLIKUAI, string V_YWY, string V_LTYPE, string V_TYPEVALUE, string V_SLY, string V_SLM, string V_SHUILIANG, string V_JINE)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_YS_CX_YUEYONGSQK");
            storedParams[0].Value = V_ZHANDIAN;
            storedParams[1].Value = V_GUANLIKUAI;
            storedParams[2].Value = V_YWY;
            storedParams[3].Value = V_LTYPE;
            storedParams[4].Value = V_TYPEVALUE;
            storedParams[5].Value = V_SLY;
            storedParams[6].Value = V_SLM;
            storedParams[7].Value = V_SHUILIANG;
            storedParams[8].Value = V_JINE;
            DataSet ds = BaseDBHelper.RunSearch("P_YS_CX_YUEYONGSQK", storedParams);
            return ds;
        }

        public static DataSet P_YS_CX_YUEYONGSQK_YB(string V_ZHANDIAN, string V_GUANLIKUAI, string V_YWY, string V_LTYPE, string V_TYPEVALUE, string V_SLY, string V_SLM, string V_SHUILIANG, string V_JINE)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_YS_CX_YUEYONGSQK_YB");
            storedParams[0].Value = V_ZHANDIAN;
            storedParams[1].Value = V_GUANLIKUAI;
            storedParams[2].Value = V_YWY;
            storedParams[3].Value = V_LTYPE;
            storedParams[4].Value = V_TYPEVALUE;
            storedParams[5].Value = V_SLY;
            storedParams[6].Value = V_SLM;
            storedParams[7].Value = V_SHUILIANG;
            storedParams[8].Value = V_JINE;
            DataSet ds = BaseDBHelper.RunSearch("P_YS_CX_YUEYONGSQK_YB", storedParams);
            return ds;
        }

        public static DataSet P_YSSF_GETZPXJFWSFJLHZ(DateTime? V_SHOUFEIRQ, string V_ZWYM)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_YSSF_GETZPXJFWSFJLHZ");
            storedParams[0].Value = V_SHOUFEIRQ;
            storedParams[1].Value = V_ZWYM;
            return BaseDBHelper.RunSearch("P_YSSF_GETZPXJFWSFJLHZ", storedParams);
        }

        public static DataSet P_QSSF_GETZPXJFWSFJLHZ(DateTime? V_SHOUFEIRQ, string V_ZWYM)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_QSSF_GETZPXJFWSFJLHZ");
            storedParams[0].Value = V_SHOUFEIRQ;
            storedParams[1].Value = V_ZWYM;
            return BaseDBHelper.RunSearch("P_QSSF_GETZPXJFWSFJLHZ", storedParams);
        }

        public static DataSet P_YS_CX_YUEYONGSHZ(string V_ZHANDIAN, string V_GUANLIKUAI, string V_YWY, int? V_LTYPE, int? V_SLY, int? V_SLM)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_YS_CX_YUEYONGSHZ");
            storedParams[0].Value = V_ZHANDIAN;
            storedParams[1].Value = V_GUANLIKUAI;
            storedParams[2].Value = V_YWY;
            storedParams[3].Value = V_LTYPE;
            storedParams[4].Value = V_SLY;
            storedParams[5].Value = V_SLM;

            DataSet ds = BaseDBHelper.RunSearch("P_YS_CX_YUEYONGSHZ", storedParams);
            
            if (storedParams[4].Value is System.DBNull)
            {
                V_SLY = null;
            }
            else
            {
                V_SLY = Convert.ToInt32(storedParams[4].Value);
            }
            if (storedParams[5].Value is System.DBNull)
            {
                V_SLM = null;
            }
            else
            {
                V_SLM = Convert.ToInt32(storedParams[5].Value);
            }
            return ds;
        }

        public static DataSet P_YS_CX_YUEYONGSHZ_YB(string V_ZHANDIAN, string V_GUANLIKUAI, string V_YWY, int? V_LTYPE, int? V_SLY, int? V_SLM)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_YS_CX_YUEYONGSHZ_YB");
            storedParams[0].Value = V_ZHANDIAN;
            storedParams[1].Value = V_GUANLIKUAI;
            storedParams[2].Value = V_YWY;
            storedParams[3].Value = V_LTYPE;
            storedParams[4].Value = V_SLY;
            storedParams[5].Value = V_SLM;

            DataSet ds = BaseDBHelper.RunSearch("P_YS_CX_YUEYONGSHZ_YB", storedParams);

            if (storedParams[4].Value is System.DBNull)
            {
                V_SLY = null;
            }
            else
            {
                V_SLY = Convert.ToInt32(storedParams[4].Value);
            }
            if (storedParams[5].Value is System.DBNull)
            {
                V_SLM = null;
            }
            else
            {
                V_SLM = Convert.ToInt32(storedParams[5].Value);
            }
            return ds;
        }
        public static DataSet P_YS_CX_YONGHUQNSFQK(string V_S_YONGHUH, string V_S_YONGHUM, int? V_I_Y)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_YS_CX_YONGHUQNSFQK");
            storedParams[0].Value = V_S_YONGHUH;
            storedParams[1].Value = V_S_YONGHUM;
            storedParams[2].Value = V_I_Y;
            DataSet ds = BaseDBHelper.RunSearch("P_YS_CX_YONGHUQNSFQK", storedParams);
            
            if (storedParams[2].Value is System.DBNull)
            {
                V_I_Y = null;
            }
            else
            {
                V_I_Y = Convert.ToInt32(storedParams[2].Value);
            }
            return ds;
        }
        public static DataSet P_YS_CX_YONGHUSFQK(string V_S_ZHANDIANBH, string V_S_GUANLIKBH, string V_S_YEWUY, int? V_TYPE, string V_TYPE_VALUE, int? V_I_Y, int? V_I_M)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_YS_CX_YONGHUSFQK");
            storedParams[0].Value = V_S_ZHANDIANBH;
            storedParams[1].Value = V_S_GUANLIKBH;
            storedParams[2].Value = V_S_YEWUY;
            storedParams[3].Value = V_TYPE;
            storedParams[4].Value = V_TYPE_VALUE;
            storedParams[5].Value = V_I_Y;
            storedParams[6].Value = V_I_M;
            DataSet ds = BaseDBHelper.RunSearch("P_YS_CX_YONGHUSFQK", storedParams);
            
            if (storedParams[5].Value is System.DBNull)
            {
                V_I_Y = null;
            }
            else
            {
                V_I_Y = Convert.ToInt32(storedParams[5].Value);
            }
            if (storedParams[6].Value is System.DBNull)
            {
                V_I_M = null;
            }
            else
            {
                V_I_M = Convert.ToInt32(storedParams[6].Value);
            }
            return ds;
        }
        public static DataSet P_YS_CX_QNSFHZ(string V_S_ZHANDIANBH, string V_S_GUANLIKH, string V_S_YEWUY, int? V_TYPE, int? V_I_Y, int? V_I_M)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_YS_CX_QNSFHZ");
            storedParams[0].Value = V_S_ZHANDIANBH;
            storedParams[1].Value = V_S_GUANLIKH;
            storedParams[2].Value = V_S_YEWUY;
            storedParams[3].Value = V_TYPE;
            storedParams[4].Value = V_I_Y;
            storedParams[5].Value = V_I_M;
            DataSet ds = BaseDBHelper.RunSearch("P_YS_CX_QNSFHZ", storedParams);
            
            if (storedParams[4].Value is System.DBNull)
            {
                V_I_Y = null;
            }
            else
            {
                V_I_Y = Convert.ToInt32(storedParams[4].Value);
            }
            if (storedParams[5].Value is System.DBNull)
            {
                V_I_M = null;
            }
            else
            {
                V_I_M = Convert.ToInt32(storedParams[5].Value);
            }
            return ds;
        }
        public static DataSet P_YS_CX_YEWUYQNSFQK(string V_S_ZHANDIANBH, string V_S_GUANLIKH, string V_S_YEWUY, int? V_I_Y, int? V_I_M)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_YS_CX_YEWUYQNSFQK");
            storedParams[0].Value = V_S_ZHANDIANBH;
            storedParams[1].Value = V_S_GUANLIKH;
            storedParams[2].Value = V_S_YEWUY;
            storedParams[3].Value = V_I_Y;
            storedParams[4].Value = V_I_M;
            DataSet ds = BaseDBHelper.RunSearch("P_YS_CX_YEWUYQNSFQK", storedParams);
            
            if (storedParams[3].Value is System.DBNull)
            {
                V_I_Y = null;
            }
            else
            {
                V_I_Y = Convert.ToInt32(storedParams[3].Value);
            }
            if (storedParams[4].Value is System.DBNull)
            {
                V_I_M = null;
            }
            else
            {
                V_I_M = Convert.ToInt32(storedParams[4].Value);
            }
            return ds;
        }

        public static DataSet P_YSCX_ZLSGSSJCX_KHL1(string V_Y, string V_M)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_YSCX_ZLSGSSJCX_KHL1");
            storedParams[0].Value = V_Y;
            storedParams[1].Value = V_M;
            DataSet ds = BaseDBHelper.RunSearch("P_YSCX_ZLSGSSJCX_KHL1", storedParams);
            return ds;
        }

        public static DataSet P_YSCX_ZLSGSSJCX_KHL2(string V_Y, string V_M)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_YSCX_ZLSGSSJCX_KHL2");
            storedParams[0].Value = V_Y;
            storedParams[1].Value = V_M;
            DataSet ds = BaseDBHelper.RunSearch("P_YSCX_ZLSGSSJCX_KHL2", storedParams);
            return ds;
        }

        public static DataSet P_YSCX_ZLSGSSJCX_JHYSL1(int? V_Y, int? V_M)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_YSCX_ZLSGSSJCX_JHYSL1");
            storedParams[0].Value = V_Y;
            storedParams[1].Value = V_M;
            DataSet ds = BaseDBHelper.RunSearch("P_YSCX_ZLSGSSJCX_JHYSL1", storedParams);
            if (storedParams[0].Value is System.DBNull)
            {
                V_Y = null;
            }
            else
            {
                V_Y = Convert.ToInt32(storedParams[0].Value);
            }
            if (storedParams[1].Value is System.DBNull)
            {
                V_M = null;
            }
            else
            {
                V_M = Convert.ToInt32(storedParams[1].Value);
            }
            return ds;
        }

        public static DataSet P_YSCX_ZLSGSSJCX_JHYSL2(int? V_Y, int? V_M)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_YSCX_ZLSGSSJCX_JHYSL2");
            storedParams[0].Value = V_Y;
            storedParams[1].Value = V_M;
            DataSet ds = BaseDBHelper.RunSearch("P_YSCX_ZLSGSSJCX_JHYSL2", storedParams);
            if (storedParams[0].Value is System.DBNull)
            {
                V_Y = null;
            }
            else
            {
                V_Y = Convert.ToInt32(storedParams[0].Value);
            }
            if (storedParams[1].Value is System.DBNull)
            {
                V_M = null;
            }
            else
            {
                V_M = Convert.ToInt32(storedParams[1].Value);
            }
            return ds;
        }

        public static DataSet P_YSCX_ZLSGSSJCX_SKHSLFX2(int? V_Y, string V_M, string V_DEPT, string V_AREA)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_YSCX_ZLSGSSJCX_SKHSLFX2");
            storedParams[0].Value = V_Y;
            storedParams[1].Value = V_M;
            storedParams[2].Value = V_DEPT;
            storedParams[3].Value = V_AREA;
            DataSet ds = BaseDBHelper.RunSearch("P_YSCX_ZLSGSSJCX_SKHSLFX2", storedParams);
            if (storedParams[0].Value is System.DBNull)
            {
                V_Y = null;
            }
            else
            {
                V_Y = Convert.ToInt32(storedParams[0].Value);
            }
            return ds;
        }

        #region 财税接口
        public static DataSet P_YS_ZW_CSJKSCSJ(string V_ZWNY, out string V_ERRMSG)
        {
            return P_YS_ZW_CSJKSCSJ(V_ZWNY, out V_ERRMSG, null);
        }
        public static DataSet P_YS_ZW_CSJKSCSJ(string V_ZWNY, out string V_ERRMSG, OracleTransaction trans)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_QS_ZW_CSJKSCSJ");
            storedParams[0].Value = V_ZWNY;
            DataSet ds = new DataSet();
            if (trans == null)
                ds = OracleHelper.ExecuteDataset(Platform.Configuration.ConfigHelper.PlatformConnString, CommandType.StoredProcedure, "P_QS_ZW_CSJKSCSJ", storedParams);
            else
                ds = OracleHelper.ExecuteDataset(trans, CommandType.StoredProcedure, "P_QS_ZW_CSJKSCSJ", storedParams);
            if (storedParams[1].Value is System.DBNull)
            {
                V_ERRMSG = null;
            }
            else
            {
                V_ERRMSG = Convert.ToString(storedParams[1].Value);
            }
            return ds;
        }

        public static DataTable GetCaiShuiJKSCWJQ(int yiShangC)
        {
            return GetCaiShuiJKSCWJQ(yiShangC, null);
        }


        public static DataTable GetCaiShuiJKSCWJ(int yiShangC)
        {
            return GetCaiShuiJKSCWJ(yiShangC, null);
        }
        /// <summary>
        /// 获取财税接口上传文件数据
        /// </summary>
        /// <param name="yishangc"></param>
        /// <returns></returns>
        public static DataTable GetCaiShuiJKSCWJ(int yiShangC, OracleTransaction trans)
        {
            string spName = "CS_Selys_zw_caishuijkscwj";
            OracleParameter[] storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, spName);
            storedParams[0].Value = yiShangC;
            DataSet ds = null;
            if (trans == null)
                ds = OracleHelper.ExecuteDataset(Platform.Configuration.ConfigHelper.PlatformConnString, CommandType.StoredProcedure, spName, storedParams);
            else
                ds = OracleHelper.ExecuteDataset(trans, CommandType.StoredProcedure, spName, storedParams);
            if (ds != null && ds.Tables.Count > 0)
            {
                return ds.Tables[0];
            }
            else
            {
                return null;
            }
        }


        public static DataTable GetCaiShuiJKSCWJQ(int yiShangC, OracleTransaction trans)
        {
            string spName = "CS_Selqs_zw_caishuijkscwj";
            OracleParameter[] storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, spName);
            storedParams[0].Value = yiShangC;
            DataSet ds = null;
            if (trans == null)
                ds = OracleHelper.ExecuteDataset(Platform.Configuration.ConfigHelper.PlatformConnString, CommandType.StoredProcedure, spName, storedParams);
            else
                ds = OracleHelper.ExecuteDataset(trans, CommandType.StoredProcedure, spName, storedParams);
            if (ds != null && ds.Tables.Count > 0)
            {
                return ds.Tables[0];
            }
            else
            {
                return null;
            }
        }

        public static DataSet P_YS_ZW_CSJKSCWJ(int V_WJBH, int V_CZ_TYPE, out string V_ERRMSG, out string V_SHUJU)
        {
            return P_YS_ZW_CSJKSCWJ(V_WJBH, V_CZ_TYPE, out V_ERRMSG, out V_SHUJU, null);
        }

        public static DataSet P_QS_ZW_CSJKSCWJ(int V_WJBH, int V_CZ_TYPE, out string V_ERRMSG, out string V_SHUJU)
        {
            return P_QS_ZW_CSJKSCWJ(V_WJBH, V_CZ_TYPE, out V_ERRMSG, out V_SHUJU, null);
        }

        public static DataSet P_YS_ZW_CSJKSCWJ(int V_WJBH, int V_CZ_TYPE, out string V_ERRMSG, out string V_SHUJU, OracleTransaction trans)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_YS_ZW_CSJKSCWJ");
            storedParams[0].Value = V_WJBH;
            storedParams[1].Value = V_CZ_TYPE;
            DataSet ds = new DataSet();
            if (trans == null)
                ds = OracleHelper.ExecuteDataset(Platform.Configuration.ConfigHelper.PlatformConnString, CommandType.StoredProcedure, "P_YS_ZW_CSJKSCWJ", storedParams);
            else
                ds = OracleHelper.ExecuteDataset(trans, CommandType.StoredProcedure, "P_YS_ZW_CSJKSCWJ", storedParams);
            if (storedParams[2].Value is System.DBNull)
            {
                V_ERRMSG = null;
            }
            else
            {
                V_ERRMSG = Convert.ToString(storedParams[2].Value);
            }
            if (storedParams[3].Value is System.DBNull)
            {
                V_SHUJU = null;
            }
            else
            {
                V_SHUJU = Convert.ToString(storedParams[3].Value);
            }

            return ds;
        }

        public static DataSet P_QS_ZW_CSJKSCWJ(int V_WJBH, int V_CZ_TYPE, out string V_ERRMSG, out string V_SHUJU, OracleTransaction trans)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_QS_ZW_CSJKSCWJ");
            storedParams[0].Value = V_WJBH;
            storedParams[1].Value = V_CZ_TYPE;
            DataSet ds = new DataSet();
            if (trans == null)
                ds = OracleHelper.ExecuteDataset(Platform.Configuration.ConfigHelper.PlatformConnString, CommandType.StoredProcedure, "P_QS_ZW_CSJKSCWJ", storedParams);
            else
                ds = OracleHelper.ExecuteDataset(trans, CommandType.StoredProcedure, "P_QS_ZW_CSJKSCWJ", storedParams);
            if (storedParams[2].Value is System.DBNull)
            {
                V_ERRMSG = null;
            }
            else
            {
                V_ERRMSG = Convert.ToString(storedParams[2].Value);
            }
            if (storedParams[3].Value is System.DBNull)
            {
                V_SHUJU = null;
            }
            else
            {
                V_SHUJU = Convert.ToString(storedParams[3].Value);
            }

            return ds;
        }

        #endregion


        public static DataSet P_YSSF_SHUIFEIZD(string V_GUANLIK, int? V_TYPE, int? V_Y, int? V_M, int? SHOUFEI, int? PRINT)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_YSSF_SHUIFEIZD");
            storedParams[0].Value = V_GUANLIK;
            storedParams[1].Value = V_TYPE;
            storedParams[2].Value = V_Y;
            storedParams[3].Value = V_M;
            storedParams[4].Value = SHOUFEI;
            storedParams[5].Value = PRINT;
            DataSet ds = BaseDBHelper.RunSearch("P_YSSF_SHUIFEIZD", storedParams);
            return ds;
        }

        #region 支票现金付委
        public static DataSet P_YSSF_GETXJZPFWSFTJORMX(string V_GUANLIK, int? V_ZWYM, int? V_TYPE)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_YSSF_GETXJZPFWSFTJORMX");
            storedParams[0].Value = V_GUANLIK;
            storedParams[1].Value = V_ZWYM;
            storedParams[2].Value = V_TYPE;
            return BaseDBHelper.RunSearch("P_YSSF_GETXJZPFWSFTJORMX", storedParams);
        }
        #endregion

        public static DataSet P_YS_CX_XINKAOHYHHZ_NEW(string V_ZHANDIAN, string V_GUANLIKUAI, string V_YWY, string V_LTYPE, string V_TYPEVALUE, string V_SLY)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_YS_CX_XINKAOHYHHZ_NEW");
            storedParams[0].Value = V_ZHANDIAN;
            storedParams[1].Value = V_GUANLIKUAI;
            storedParams[2].Value = V_YWY;
            storedParams[3].Value = V_LTYPE;
            storedParams[4].Value = V_TYPEVALUE;
            storedParams[5].Value = V_SLY;
            DataSet ds = BaseDBHelper.RunSearch("P_YS_CX_XINKAOHYHHZ_NEW", storedParams);
            return ds;
        }

        public static DataSet P_QSSF_KZ_CHECKERROR(int? V_WTYPE, int? V_Y, int? V_M, int? V_ITYPE)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_QSSF_KZ_CHECKERROR");
            storedParams[0].Value = V_WTYPE;
            storedParams[1].Value = V_Y;
            storedParams[2].Value = V_M;
            storedParams[3].Value = V_ITYPE;
            DataSet ds = BaseDBHelper.RunSearch("P_QSSF_KZ_CHECKERROR", storedParams);
            return ds;
        }

        public static DataSet P_QSSF_JINZHANGD(int? V_WTYPE, int? V_CTYPE)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_QSSF_JINZHANGD");
            storedParams[0].Value = V_WTYPE;
            storedParams[1].Value = V_CTYPE;
            DataSet ds = BaseDBHelper.RunSearch("P_QSSF_JINZHANGD", storedParams);
            return ds;
        }

        public static DataSet P_QSCX_TUOSHOUXXCX(int? V_TYPE, int? V_CTYPE, int? V_ID)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_QSCX_TUOSHOUXXCX");
            storedParams[0].Value = V_TYPE;
            storedParams[1].Value = V_CTYPE;
            storedParams[2].Value = V_ID;
            DataSet ds = BaseDBHelper.RunSearch("P_QSCX_TUOSHOUXXCX", storedParams);
            return ds;
        }

        public static DataSet P_QR_DDY(string V_IYEAR, string V_IMONTH, decimal? V_IWATERTYPE)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_QR_DDY");
            storedParams[0].Value = V_IYEAR;
            storedParams[1].Value = V_IMONTH;
            storedParams[2].Value = V_IWATERTYPE;
            DataSet ds = BaseDBHelper.RunSearch("P_QR_DDY", storedParams);
            return ds;
        }


        public static DataSet P_QS_DXSBB0601_SC(int? V_Y, int? V_QX, int? V_JD, DateTime? V_DAYINRQ)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_QS_DXSBB0601_SC");
            storedParams[0].Value = V_Y;
            storedParams[1].Value = V_QX;
            storedParams[2].Value = V_JD;
            storedParams[3].Value = V_DAYINRQ;
            DataSet ds = BaseDBHelper.RunSearch("P_QS_DXSBB0601_SC", storedParams);
            return ds;
        }
     

        public static DataSet P_QS_QT_DAYINSJDCCX(int? V_I_WTYPE, int? V_I_YM, int? V_I_TYPE, int? V_I_QUYU, OracleTransaction trans)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_QS_QT_DAYINSJDCCX");
            storedParams[0].Value = V_I_WTYPE;
            storedParams[1].Value = V_I_YM;
            storedParams[2].Value = V_I_TYPE;
            storedParams[3].Value = V_I_QUYU;
            DataSet ds = new DataSet();
            ds = BaseDBHelper.RunSearch("P_QS_QT_DAYINSJDCCX", storedParams);
            return ds;
        }

        public static DataSet P_QS_JJSLXXHQ(string V_LAIHANBH, int? V_Y, string V_YONGHUH)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_QS_JJSLXXHQ");
            storedParams[0].Value = V_LAIHANBH;
            storedParams[1].Value = V_Y;
            storedParams[2].Value = V_YONGHUH;
            DataSet ds = BaseDBHelper.RunSearch("P_QS_JJSLXXHQ", storedParams);
            return ds;
        }

       
        public static DataSet P_QS_CX_QUANNIANQKCX(int? V_IWATERTYPE, string V_SCOMMONCONDITION, string V_SSELECTFIELD, string V_SGROUPFILED, int? V_IYEAR, int? V_IMONTH, string V_SCANTONGUID, string V_SBUSIMANGUID, string V_SID, string V_SNAME, string V_SADDR, string V_SLICENSEID, string V_SCOMPANYGUID, string V_SWPRICE, string V_SWUSAGEGUID, string V_SWELLID, string V_SWELLADDR, string V_ILAYER, string V_SWELLTYPE, string V_SWELLFLAG, string V_SWATERNUMBER, string V_SWATERAMOUNTTYPE, int? V_MONTH, string V_SINDUSTRYGUID, string V_ICIRCLELINE, int? V_ICONSIGN, string V_SBANKNAME, string V_SBANKID, string V_VALLEYGUID, string V_WATERAREAGUID, string V_WATERPIECEGUID, string V_SACCOUNTBANK, OracleTransaction trans)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_QS_CX_QUANNIANQKCX");
            storedParams[0].Value = V_IWATERTYPE;
            storedParams[1].Value = V_SCOMMONCONDITION;
            storedParams[2].Value = V_SSELECTFIELD;
            storedParams[3].Value = V_SGROUPFILED;
            storedParams[4].Value = V_IYEAR;
            storedParams[5].Value = V_IMONTH;
            storedParams[6].Value = V_SCANTONGUID;
            storedParams[7].Value = V_SBUSIMANGUID;
            storedParams[8].Value = V_SID;
            storedParams[9].Value = V_SNAME;
            storedParams[10].Value = V_SADDR;
            storedParams[11].Value = V_SLICENSEID;
            storedParams[12].Value = V_SCOMPANYGUID;
            storedParams[13].Value = V_SWPRICE;
            storedParams[14].Value = V_SWUSAGEGUID;
            storedParams[15].Value = V_SWELLID;
            storedParams[16].Value = V_SWELLADDR;
            storedParams[17].Value = V_ILAYER;
            storedParams[18].Value = V_SWELLTYPE;
            storedParams[19].Value = V_SWELLFLAG;
            storedParams[20].Value = V_SWATERNUMBER;
            storedParams[21].Value = V_SWATERAMOUNTTYPE;
            storedParams[22].Value = V_MONTH;
            storedParams[23].Value = V_SINDUSTRYGUID;
            storedParams[24].Value = V_ICIRCLELINE;
            storedParams[25].Value = V_ICONSIGN;
            storedParams[26].Value = V_SBANKNAME;
            storedParams[27].Value = V_SBANKID;
            storedParams[28].Value = V_VALLEYGUID;
            storedParams[29].Value = V_WATERAREAGUID;
            storedParams[30].Value = V_WATERPIECEGUID;
            storedParams[31].Value = V_SACCOUNTBANK;
            DataSet ds = new DataSet();

            ds = BaseDBHelper.RunSearch("P_QS_CX_QUANNIANQKCX", storedParams);
            return ds;
        }


        public static DataSet P_QS_CX_QUANNIANQKCX(int? V_IWATERTYPE, string V_SCOMMONCONDITION, string V_SSELECTFIELD, string V_SGROUPFILED, int? V_IYEAR, int? V_IMONTH, string V_SCANTONGUID, string V_SBUSIMANGUID, string V_SID, string V_SNAME, string V_SADDR, string V_SLICENSEID, string V_SCOMPANYGUID, string V_SWPRICE, string V_SWUSAGEGUID, string V_SWELLID, string V_SWELLADDR, string V_ILAYER, string V_SWELLTYPE, string V_SWELLFLAG, string V_SWATERNUMBER, string V_SWATERAMOUNTTYPE, int? V_MONTH, string V_SINDUSTRYGUID, string V_ICIRCLELINE, int? V_ICONSIGN, string V_SBANKNAME, string V_SBANKID, string V_VALLEYGUID, string V_WATERAREAGUID, string V_WATERPIECEGUID, string V_SACCOUNTBANK)
        {
            return P_QS_CX_QUANNIANQKCX(V_IWATERTYPE, V_SCOMMONCONDITION, V_SSELECTFIELD, V_SGROUPFILED, V_IYEAR, V_IMONTH, V_SCANTONGUID, V_SBUSIMANGUID, V_SID, V_SNAME, V_SADDR, V_SLICENSEID, V_SCOMPANYGUID, V_SWPRICE, V_SWUSAGEGUID, V_SWELLID, V_SWELLADDR, V_ILAYER, V_SWELLTYPE, V_SWELLFLAG, V_SWATERNUMBER, V_SWATERAMOUNTTYPE, V_MONTH, V_SINDUSTRYGUID, V_ICIRCLELINE, V_ICONSIGN, V_SBANKNAME, V_SBANKID, V_VALLEYGUID, V_WATERAREAGUID, V_WATERPIECEGUID, V_SACCOUNTBANK, null);
        }
        public static DataSet P_QS_CX_QUANNIANQKCXXXXX(int? V_IWATERTYPE, int y,string yonghuh)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_QS_CX_QUANNIANQKCXXXXX");
            storedParams[0].Value = V_IWATERTYPE;
            storedParams[1].Value = y;
            storedParams[2].Value = yonghuh;
           
            DataSet ds = new DataSet();

            ds = BaseDBHelper.RunSearch("P_QS_CX_QUANNIANQKCXXXXX", storedParams);
            return ds;
        }


        public static DataSet P_QSCX_ZWCX_DUOSHOU(int? V_TYPE, int? V_ZWY, int? V_ZWM, int? V_HNHW, string V_XZQ, string V_YHH, string V_YHM, string V_QSYT, string V_HYLX, string V_ZGBM, string V_YM, string V_JE)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_QSCX_ZWCX_DUOSHOU");
            storedParams[0].Value = V_TYPE;
            storedParams[1].Value = V_ZWY;
            storedParams[2].Value = V_ZWM;
            storedParams[3].Value = V_HNHW;
            storedParams[4].Value = V_XZQ;
            storedParams[5].Value = V_YHH;
            storedParams[6].Value = V_YHM;
            storedParams[7].Value = V_QSYT;
            storedParams[8].Value = V_HYLX;
            storedParams[9].Value = V_ZGBM;
            storedParams[10].Value = V_YM;
            storedParams[11].Value = V_JE;
            DataSet ds = BaseDBHelper.RunSearch("P_QSCX_ZWCX_DUOSHOU", storedParams);
            return ds;
        }
        public static DataSet P_QS_CX_QUANNIANYCX(int? V_IWATERTYPE, int y, int m ,string sql)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_QS_CX_QUANNIANYCX");
            storedParams[0].Value = V_IWATERTYPE;
            storedParams[1].Value = y;
            storedParams[2].Value = m;
            storedParams[3].Value = sql;

            DataSet ds = new DataSet();

            ds = BaseDBHelper.RunSearch("P_QS_CX_QUANNIANYCX", storedParams);
            return ds;
        }
        public static DataSet P_QS_CX_QUANNIANCXYGZ(int? V_IWATERTYPE, int y, int m, string sql,int V_TYPE)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_QS_CX_QUANNIANCXYGZ");
            storedParams[0].Value = V_IWATERTYPE;
            storedParams[1].Value = y;
            storedParams[2].Value = m;
            storedParams[3].Value = sql;
            storedParams[4].Value = V_TYPE;
            DataSet ds = new DataSet();

            ds = BaseDBHelper.RunSearch("P_QS_CX_QUANNIANCXYGZ", storedParams);
            return ds;
        }

        public static DataSet P_QSCX_ZWCX_SHUIZIYF(int? V_TYPE, int? V_ZWY, int? V_ZWM, int? V_HNHW, string V_XZQ, string V_YHH, string V_YHM, string V_QSYT, string V_HYLX, string V_ZGBM, string V_YM, string V_JE, string V_SZYSJ)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_QSCX_ZWCX_SHUIZIYF");
            storedParams[0].Value = V_TYPE;
            storedParams[1].Value = V_ZWY;
            storedParams[2].Value = V_ZWM;
            storedParams[3].Value = V_HNHW;
            storedParams[4].Value = V_XZQ;
            storedParams[5].Value = V_YHH;
            storedParams[6].Value = V_YHM;
            storedParams[7].Value = V_QSYT;
            storedParams[8].Value = V_HYLX;
            storedParams[9].Value = V_ZGBM;
            storedParams[10].Value = V_YM;
            storedParams[11].Value = V_JE;
            storedParams[12].Value = V_SZYSJ;
            DataSet ds = BaseDBHelper.RunSearch("P_QSCX_ZWCX_SHUIZIYF", storedParams);
            return ds;
        }
        public static DataSet P_QS_CX_YONGHUSFCX(int? V_IWATERTYPE, int y, int m, string sql, int V_TYPE)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_QS_CX_YONGHUSFCX");
            storedParams[0].Value = V_IWATERTYPE;
            storedParams[1].Value = y;
            storedParams[2].Value = m;
            storedParams[3].Value = sql;
            storedParams[4].Value = V_TYPE;
            DataSet ds = new DataSet();

            ds = BaseDBHelper.RunSearch("P_QS_CX_YONGHUSFCX", storedParams);
            return ds;
        }

        public static DataSet P_QSCX_ZWCX_TUIPIAO(int? V_TYPE, int? V_ZWY, int? V_ZWM, int? V_HNHW, string V_XZQ, string V_YHH, string V_YHM, string V_QSYT, string V_HYLX, string V_ZGBM, string V_SLYM, string V_JE, string V_SG)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_QSCX_ZWCX_TUIPIAO");
            storedParams[0].Value = V_TYPE;
            storedParams[1].Value = V_ZWY;
            storedParams[2].Value = V_ZWM;
            storedParams[3].Value = V_HNHW;
            storedParams[4].Value = V_XZQ;
            storedParams[5].Value = V_YHH;
            storedParams[6].Value = V_YHM;
            storedParams[7].Value = V_QSYT;
            storedParams[8].Value = V_HYLX;
            storedParams[9].Value = V_ZGBM;
            storedParams[10].Value = V_SLYM;
            storedParams[11].Value = V_JE;
            storedParams[12].Value = V_SG;
            DataSet ds = BaseDBHelper.RunSearch("P_QSCX_ZWCX_TUIPIAO", storedParams);
            return ds;
        }

        public static DataSet P_QS_CX_QUANNIANSFHZCX(int? V_IWATERTYPE, int y, int m, string sql, int V_TYPE)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_QS_CX_QUANNIANSFHZCX");
            storedParams[0].Value = V_IWATERTYPE;
            storedParams[1].Value = y;
            storedParams[2].Value = m;
            storedParams[3].Value = sql;
            storedParams[4].Value = V_TYPE;
            DataSet ds = new DataSet();

            ds = BaseDBHelper.RunSearch("P_QS_CX_QUANNIANSFHZCX", storedParams);
            return ds;
        }

        public static DataSet P_QSCX_SBQNYSQK(int? V_TYPE, int? V_Y, int? V_M, string V_YHH, string V_JBH, string V_SBBH, string V_YHM, string V_XKZ, string V_QSDZ, string V_QSYT, string V_HYFL, string V_LY, string V_SZYFQ, string V_SLFP, string V_SLLB, string V_CH, string V_SJ, string V_SJSF, string V_SL, int? V_ID)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_QSCX_SBQNYSQK");
            storedParams[0].Value = V_TYPE;
            storedParams[1].Value = V_Y;
            storedParams[2].Value = V_M;
            storedParams[3].Value = V_YHH;
            storedParams[4].Value = V_JBH;
            storedParams[5].Value = V_SBBH;
            storedParams[6].Value = V_YHM;
            storedParams[7].Value = V_XKZ;
            storedParams[8].Value = V_QSDZ;
            storedParams[9].Value = V_QSYT;
            storedParams[10].Value = V_HYFL;
            storedParams[11].Value = V_LY;
            storedParams[12].Value = V_SZYFQ;
            storedParams[13].Value = V_SLFP;
            storedParams[14].Value = V_SLLB;
            storedParams[15].Value = V_CH;
            storedParams[16].Value = V_SJ;
            storedParams[17].Value = V_SJSF;
            storedParams[18].Value = V_SL;
            storedParams[19].Value = V_ID;
            DataSet ds = BaseDBHelper.RunSearch("P_QSCX_SBQNYSQK", storedParams);
            return ds;
        }

        public static DataSet P_QSCX_SBYYSHZ(int? V_TYPE, int? V_HZFL, int? V_Y, int? V_M, string V_YHH, string V_JBH, string V_SBBH, string V_YHM, string V_XKZ, string V_QSDZ, string V_QSYT, string V_HYFL, string V_LY, string V_SZYFQ, string V_SLFP, string V_SLLB, string V_CH, string V_SJ, string V_SJSF, string V_SL)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_QSCX_SBYYSHZ");
            storedParams[0].Value = V_TYPE;
            storedParams[1].Value = V_HZFL;
            storedParams[2].Value = V_Y;
            storedParams[3].Value = V_M;
            storedParams[4].Value = V_YHH;
            storedParams[5].Value = V_JBH;
            storedParams[6].Value = V_SBBH;
            storedParams[7].Value = V_YHM;
            storedParams[8].Value = V_XKZ;
            storedParams[9].Value = V_QSDZ;
            storedParams[10].Value = V_QSYT;
            storedParams[11].Value = V_HYFL;
            storedParams[12].Value = V_LY;
            storedParams[13].Value = V_SZYFQ;
            storedParams[14].Value = V_SLFP;
            storedParams[15].Value = V_SLLB;
            storedParams[16].Value = V_CH;
            storedParams[17].Value = V_SJ;
            storedParams[18].Value = V_SJSF;
            storedParams[19].Value = V_SL;
            DataSet ds = BaseDBHelper.RunSearch("P_QSCX_SBYYSHZ", storedParams);
            return ds;
        }


        public static DataSet P_QSSF_KAIZHANG(int? V_WTYPE, string V_SVAL, int? V_Y, int? V_M, string V_USERID, int? V_ZWYM, int? V_ITYPE)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_QSSF_KAIZHANG");
            storedParams[0].Value = V_WTYPE;
            storedParams[1].Value = V_SVAL;
            storedParams[2].Value = V_Y;
            storedParams[3].Value = V_M;
            storedParams[4].Value = V_USERID;
            storedParams[5].Value = V_ZWYM;
            storedParams[6].Value = V_ITYPE;
            DataSet ds = new DataSet();

            ds = BaseDBHelper.RunSearch("P_QSSF_KAIZHANG", storedParams);
            return ds;
        }

        public static DataSet P_QSCX_ZWCX_BENYUEDZ(int? V_TYPE, int? V_ZWY, int? V_ZWM, int? V_HNHW, string V_XZQ, string V_YHH, string V_YHM, string V_QSYT, string V_HYLX, string V_ZGBM, int? V_YM, string V_JE, string V_DZFL, string V_SFFS, string V_FYLX)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_QSCX_ZWCX_BENYUEDZ");
            storedParams[0].Value = V_TYPE;
            storedParams[1].Value = V_ZWY;
            storedParams[2].Value = V_ZWM;
            storedParams[3].Value = V_HNHW;
            storedParams[4].Value = V_XZQ;
            storedParams[5].Value = V_YHH;
            storedParams[6].Value = V_YHM;
            storedParams[7].Value = V_QSYT;
            storedParams[8].Value = V_HYLX;
            storedParams[9].Value = V_ZGBM;
            storedParams[10].Value = V_YM;
            storedParams[11].Value = V_JE;
            storedParams[12].Value = V_DZFL;
            storedParams[13].Value = V_SFFS;
            storedParams[14].Value = V_FYLX;
            DataSet ds = new DataSet();
            ds = BaseDBHelper.RunSearch("P_QSCX_ZWCX_BENYUEDZ", storedParams);
            return ds;
        }

        public static DataSet P_QS_CX_QUANNIANQKCX_DXS(int? V_TYPE, int? V_YEAR, string V_XINGZHENGQ, string V_YWY, string V_YONGHUH, string V_YONGHUM, string V_DIZHI, string V_BUMEN, string V_SHUIJIA, string V_QUSHUIYT,  string V_HANGYELX, string V_HUANXIANBJ, int? V_SHOUFEIFS, string V_KAIHUHM, string V_KAIHUZH, string V_LIUYU, string V_SHUIZIYFQ, string V_SHUILIFP)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_QS_CX_QUANNIANQKCX_DXS");
            storedParams[0].Value = V_TYPE;
            storedParams[1].Value = V_YEAR;
            storedParams[2].Value = V_XINGZHENGQ;
            storedParams[3].Value = V_YWY;
            storedParams[4].Value = V_YONGHUH;
            storedParams[5].Value = V_YONGHUM;
            storedParams[6].Value = V_DIZHI;
            storedParams[7].Value = V_BUMEN;
            storedParams[8].Value = V_SHUIJIA;
            storedParams[9].Value = V_QUSHUIYT;
            storedParams[11].Value = V_HANGYELX;
            storedParams[12].Value = V_HUANXIANBJ;
            storedParams[13].Value = V_SHOUFEIFS;
            storedParams[14].Value = V_KAIHUHM;
            storedParams[15].Value = V_KAIHUZH;
            storedParams[16].Value = V_LIUYU;
            storedParams[17].Value = V_SHUIZIYFQ;
            storedParams[18].Value = V_SHUILIFP;
            DataSet ds = BaseDBHelper.RunSearch("P_QS_CX_QUANNIANQKCX_DXS", storedParams);
            return ds;
        }

        public static DataSet P_QS_CX_QUANNIANQKCX_DBS(int? V_TYPE, int? V_YEAR, string V_XINGZHENGQ, string V_YWY, string V_YONGHUH, string V_YONGHUM, string V_DIZHI, string V_BUMEN, string V_SHUIJIA, string V_QUSHUIYT,string V_HANGYELX, string V_HUANXIANBJ, int? V_SHOUFEIFS, string V_KAIHUHM, string V_KAIHUZH, string V_LIUYU, string V_SHUIZIYFQ, string V_SHUILIFP)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_QS_CX_QUANNIANQKCX_DBS");
            storedParams[0].Value = V_TYPE;
            storedParams[1].Value = V_YEAR;
            storedParams[2].Value = V_XINGZHENGQ;
            storedParams[3].Value = V_YWY;
            storedParams[4].Value = V_YONGHUH;
            storedParams[5].Value = V_YONGHUM;
            storedParams[6].Value = V_DIZHI;
            storedParams[7].Value = V_BUMEN;
            storedParams[8].Value = V_SHUIJIA;
            storedParams[9].Value = V_QUSHUIYT;
            storedParams[11].Value = V_HANGYELX;
            storedParams[12].Value = V_HUANXIANBJ;
            storedParams[13].Value = V_SHOUFEIFS;
            storedParams[14].Value = V_KAIHUHM;
            storedParams[15].Value = V_KAIHUZH;
            storedParams[16].Value = V_LIUYU;
            storedParams[17].Value = V_SHUIZIYFQ;
            storedParams[18].Value = V_SHUILIFP;
            DataSet ds = BaseDBHelper.RunSearch("P_QS_CX_QUANNIANQKCX_DBS", storedParams);
            return ds;
        }
        public static DataSet P_QS_CX_YONGHUSFQK(int? V_WTYPE,int? V_TYPE, int? V_YEAR, int? V_MONTH, string V_XINGZHENGQ, string V_YWY, string V_YONGHUH, string V_YONGHUM, string V_DIZHI, string V_BUMEN, string V_SHUIJIA, string V_QUSHUIYT, string V_HANGYELX, string V_HUANXIANBJ, int? V_SHOUFEIFS, string V_KAIHUHM, string V_KAIHUZH, string V_LIUYU, string V_SHUIZIYFQ, string V_SHUILIFP)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_QS_CX_YONGHUSFQK");
            storedParams[0].Value = V_WTYPE;
            storedParams[1].Value = V_TYPE;
            storedParams[2].Value = V_YEAR;
            storedParams[3].Value = V_MONTH;
            storedParams[4].Value = V_XINGZHENGQ;
            storedParams[5].Value = V_YWY;
            storedParams[6].Value = V_YONGHUH;
            storedParams[7].Value = V_YONGHUM;
            storedParams[8].Value = V_DIZHI;
            storedParams[9].Value = V_BUMEN;
            storedParams[10].Value = V_SHUIJIA;
            storedParams[11].Value = V_QUSHUIYT;
            storedParams[12].Value = V_HANGYELX;
            storedParams[13].Value = V_HUANXIANBJ;
            storedParams[14].Value = V_SHOUFEIFS;
            storedParams[15].Value = V_KAIHUHM;
            storedParams[16].Value = V_KAIHUZH;
            storedParams[17].Value = V_LIUYU;
            storedParams[18].Value = V_SHUIZIYFQ;
            storedParams[19].Value = V_SHUILIFP;
            return BaseDBHelper.RunSearch("P_QS_CX_YONGHUSFQK", storedParams);
        }

        public static DataSet P_QS_CX_SHENJINXXCX_SL(int? V_TYPE, int? V_HZTYPE, int? V_Y, int? V_M, string V_HUANXIANBJ, string V_XINGZHENGQ, string V_LAOBH, string V_JINLX, string V_JINXZ, string V_JINBJ, string V_SHUILIANGLB, string V_SHUILIANGTJ, decimal? V_SHUILIANG, string V_YONGHUH, string V_YONGHUM, string V_DIZHI, string V_JINBH, string V_XUKEZH, string V_QUSHUIDZ, string V_QUSHUIYT, string V_HANGYELX, string V_BUMEN, string V_LIUYU, string V_SHUIZIYFQ, string V_SHUILIFP, string V_SHENJINSFTJ, decimal? V_SHENJINSF, string V_CENGCI, string V_XIAOJINNYTJ1, string V_XIAOJINNY1, string V_XIAOJINNYTJ2, string V_XIAOJINNY2)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_QS_CX_SHENJINXXCX_SL");
            storedParams[0].Value = V_TYPE;
            storedParams[1].Value = V_HZTYPE;
            storedParams[2].Value = V_Y;
            storedParams[3].Value = V_M;
            storedParams[4].Value = V_HUANXIANBJ;
            storedParams[5].Value = V_XINGZHENGQ;
            storedParams[6].Value = V_LAOBH;
            storedParams[7].Value = V_JINLX;
            storedParams[8].Value = V_JINXZ;
            storedParams[9].Value = V_JINBJ;
            storedParams[10].Value = V_SHUILIANGLB;
            storedParams[11].Value = V_SHUILIANGTJ;
            storedParams[12].Value = V_SHUILIANG;
            storedParams[13].Value = V_YONGHUH;
            storedParams[14].Value = V_YONGHUM;
            storedParams[15].Value = V_DIZHI;
            storedParams[16].Value = V_JINBH;
            storedParams[17].Value = V_XUKEZH;
            storedParams[18].Value = V_QUSHUIDZ;
            storedParams[19].Value = V_QUSHUIYT;
            storedParams[20].Value = V_HANGYELX;
            storedParams[21].Value = V_BUMEN;
            storedParams[22].Value = V_LIUYU;
            storedParams[23].Value = V_SHUIZIYFQ;
            storedParams[24].Value = V_SHUILIFP;
            storedParams[25].Value = V_SHENJINSFTJ;
            storedParams[26].Value = V_SHENJINSF;
            storedParams[27].Value = V_CENGCI;
            storedParams[28].Value = V_XIAOJINNYTJ1;
            storedParams[29].Value = V_XIAOJINNY1;
            storedParams[30].Value = V_XIAOJINNYTJ2;
            storedParams[31].Value = V_XIAOJINNY2;
            return BaseDBHelper.RunSearch("P_QS_CX_SHENJINXXCX_SL", storedParams);
        }

        public static DataSet P_QSCX_CHAOBIAOSJCX(int? V_TYPE, int? V_KSNY, int? V_JSNY, int? V_HNHW, string V_XZQ, string V_YWY, int? V_BS, string V_CONSTR, int? V_ID)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_QSCX_CHAOBIAOSJCX");
            storedParams[0].Value = V_TYPE;
            storedParams[1].Value = V_KSNY;
            storedParams[2].Value = V_JSNY;
            storedParams[3].Value = V_HNHW;
            storedParams[4].Value = V_XZQ;
            storedParams[5].Value = V_YWY;
            storedParams[6].Value = V_BS;
            storedParams[7].Value = V_CONSTR;
            storedParams[8].Value = V_ID;
            return BaseDBHelper.RunSearch("P_QSCX_CHAOBIAOSJCX", storedParams);
        }

        public static DataSet P_QSCX_SBQNYSQK2(int? V_WTYPE, int? V_Y, string V_SBH)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_QSCX_SBQNYSQK2");
            storedParams[0].Value = V_WTYPE;
            storedParams[1].Value = V_Y;
            storedParams[2].Value = V_SBH;
            return BaseDBHelper.RunSearch("P_QSCX_SBQNYSQK2", storedParams);
        }

        public static DataSet P_YSCX_BENYUEDZ(int? V_ZWYM1, int? V_ZWYM2, string V_ZD, string V_GLK, string V_YWY, string V_SLYM, string V_YHH, string V_YHM, string V_DZFL, string V_SFFS, int? V_PCSYYS, int? V_BHSYYS, string V_SFJE)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_YSCX_BENYUEDZ");
            storedParams[0].Value = V_ZWYM1;
            storedParams[1].Value = V_ZWYM2;
            storedParams[2].Value = V_ZD;
            storedParams[3].Value = V_GLK;
            storedParams[4].Value = V_YWY;
            storedParams[5].Value = V_SLYM;
            storedParams[6].Value = V_YHH;
            storedParams[7].Value = V_YHM;
            storedParams[8].Value = V_DZFL;
            storedParams[9].Value = V_SFFS;
            storedParams[10].Value = V_PCSYYS;
            storedParams[11].Value = V_BHSYYS;
            storedParams[12].Value = V_SFJE;

            return BaseDBHelper.RunSearch("P_YSCX_BENYUEDZ", storedParams);
          
        }

        public static DataSet P_DBSZW_FEISHUISCXXSC(out string V_FILENAME, out string V_RETURNNO, out string V_RETURNMSG)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_DBSZW_FEISHUISCXXSC");
            DataSet ds = BaseDBHelper.RunSearch("P_DBSZW_FEISHUISCXXSC", storedParams);
            V_FILENAME = storedParams[0].Value is System.DBNull ? null : (string)storedParams[0].Value;
            V_RETURNNO = storedParams[1].Value is System.DBNull ? null : (string)storedParams[1].Value;
            V_RETURNMSG = storedParams[2].Value is System.DBNull ? null : (string)storedParams[2].Value;
            return ds;
        }

        public static DataSet P_QSCX_QUJIANCX_DXS(int? V_YEAR1, int? V_M1, int? V_YEAR2, int? V_M2, string V_XINGZHENGQ, string V_YWY, string V_YONGHUH, string V_YONGHUM, string V_DIZHI, string V_BUMEN, string V_SHUIJIA, string V_QUSHUIYT, string V_HANGYELX, string V_HUANXIANBJ, int? V_SHOUFEIFS, string V_KAIHUHM, string V_KAIHUZH, string V_LIUYU, string V_SHUIZIYFQ, string V_SHUILIFP)
        {
            OracleParameter[] storedParams;
            storedParams = OracleHelperParameterCache.GetSpParameterSet(Platform.Configuration.ConfigHelper.PlatformConnString, "P_QSCX_QUJIANCX_DXS");
            storedParams[0].Value = V_YEAR1;
            storedParams[1].Value = V_M1;
            storedParams[2].Value = V_YEAR2;
            storedParams[3].Value = V_M2;
            storedParams[4].Value = V_XINGZHENGQ;
            storedParams[5].Value = V_YWY;
            storedParams[6].Value = V_YONGHUH;
            storedParams[7].Value = V_YONGHUM;
            storedParams[8].Value = V_DIZHI;
            storedParams[9].Value = V_BUMEN;
            storedParams[10].Value = V_SHUIJIA;
            storedParams[11].Value = V_QUSHUIYT;
            storedParams[12].Value = V_HANGYELX;
            storedParams[13].Value = V_HUANXIANBJ;
            storedParams[14].Value = V_SHOUFEIFS;
            storedParams[15].Value = V_KAIHUHM;
            storedParams[16].Value = V_KAIHUZH;
            storedParams[17].Value = V_LIUYU;
            storedParams[18].Value = V_SHUIZIYFQ;
            storedParams[19].Value = V_SHUILIFP;
            return BaseDBHelper.RunSearch("P_QSCX_QUJIANCX_DXS", storedParams);
        }
    }
}
